# -*- coding : utf_8 -*-
"""
=======================================
Time : 2025/4/14 10:45
Author : 田霄汉
Email : 522989570@qq.com
File : combat_class18.py
Project : pandas_demo
Function : 表格旋转
=======================================
"""
import pandas as pd
from pandas import DataFrame
from config.setting import file_path

pd.options.display.max_columns = 999
combat18_path = file_path['excel_path'] + '/combat18.xlsx'
Score_df: DataFrame = pd.read_excel(io=combat18_path,
                                    skiprows=3,
                                    usecols='C:E',
                                    index_col='id')
# 将表格进行旋转
new_Score_df = Score_df.transpose()
print(new_Score_df)
